package com.education.user.mapper;


import com.education.user.pojo.SysBanner;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;


public interface BannerMapper extends Mapper<SysBanner> {

    @Select("select * from sys_banner\n" +
            "        where #{sort} > sort\n" +
            "        order by sort desc")
     List<SysBanner> selectSysBannerBySortAsc(String sort);

    @Select("select * from sys_banner\n" +
            "        where sort > #{sort}\n" +
            "        order by sort asc")
     List<SysBanner> selectSysBannerBySortDesc(String sort);


}
